package com.group.EducationalSystem.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import com.group.EducationalSystem.bean.College;
import com.group.EducationalSystem.bean.Course;
import com.group.EducationalSystem.bean.ExamInformation;
import com.group.EducationalSystem.bean.Score_tab;
import com.group.EducationalSystem.bean.Student;
import com.group.EducationalSystem.bean.Teacher;
import com.group.EducationalSystem.bean.User;


@Mapper
public interface SchoolMapper {
	User getUser(@Param("account") String account,@Param("password") String password);
	Student getStudent(@Param("student_number") String student_number);
	List<College> getcollege();
	void perfectStudent(Student student);
	College getcollegebyname(@Param("college") String college);
	void changeStudent(@Param("changephone")String changephone,@Param("changebox")String changebox,@Param("changehome")String changehome,@Param("changecollege")int changecollege,@Param("number")String number);
	List<Score_tab> getachievement(@Param("student_id") int student_id);
	int getachievementnumber(@Param("student_id") int student_id);
	void uploadimage(@Param("sqlpath")String sqlpath,@Param("number")String number);
	String getimage(@Param("student_id") int student_id);
	List<Course> getcourse(@Param("college_id") int college_id);
	List<Teacher> getTeachers(@Param("teacher_id") int teacher_id);
	List<Course> getcoursebyname(@Param("college_id") int college_id,@Param("course_name") String course_name);
	List<Course> getcoursebyteacher(@Param("college_id") int college_id,@Param("teacher_name") String teacher_name);
	List<Course> getcoursebynameandteacher(@Param("college_id") int college_id,@Param("course_name") String course_name,@Param("teacher_name") String teacher_name);
	List<Score_tab> gettest(@Param("student_id") int student_id);
	List<ExamInformation> getExamInformation(@Param("student_id") int student_id);
}
